EMT Practice Test

1. Question Content...

---

Question1: Which data types are only valid when DB2_COMPATIBILITY_VECTOR=ORA? (Choose two.)

Question2: What is the schema name of the DB2 built-in global variable TRUSTED_CONTEXT?

Question3: Given the following:

What will be the result of the following SQL statement?
INSERT INTO v3 (col1) values (30);

Question4: You receive a large data file that contains large object data values that need to be copied into a table in the shortest amount of time possible. Which utility should be used?

Question5: Which of the following SQL statements will list table spaces whose utilization is greater than 95% and may potentially fill, returning an error?

Question6: When the DB2_WORKLOAD registry variable is assigned the value ANALYTICS and then a new database is created, what happens? (Choose two.)

Question7: When operating in NPS compatibility mode, which of the following are limitations for using a routine written in NZPLSQL? (Choose two.)

Question8: Which operation best describes the purpose of the SET INTEGRITY PRUNE operation?

Question9: Which security mechanism is responsible for verifying that users are indeed who the claim to be?

Question10: A production database has the following daily midnight backup schedule which includes all table spaces.
The database incurs the same volume of daily activity (inserts, updates, and deletes).
Sunday - Delta
Monday - Incremental
Tuesday - Delta
Wednesday - Delta
Thursday - Incremental
Friday - Delta
Saturday - Full
Which day would you expect a RECOVER DATABASE following that day's backup to take the longest time to complete?

Question11: The DBA has observed that queries executed against SALES table have poor performance. SALES is a compressed table and recently there have been a lot of rows inserted and modified in that table. The DBA has detected that lower performance may be the result of sub-optimal compression dictionary for that table.
Which of the following commands should be used to resolve the problem without preventing users from changing data in the SALES table

Question12: Which statement about the DB2_BCKP_COMPRESSION registry variable is TRUE?

Question13: Which statement about NOT ENFORCED unique constraints is TRUE?

Question14: On Linux and Unix systems, which of the following will set the DB2_FMP_COMM_HEAPSZ registry variable to 1 GB (or 256000 pages), only for the instance db2inst1?

Question15: Which of the following statements is TRUE?

Question16: Which statement about Data Server Manager (DSM) is TRUE?

Question17: A DBA has observed that queries executed against SALES table have poor performance. DB2 tools have indicated that the level of data fragmentation in the SALES table is very high. Similar results were detected for indexes defined on the SALES table.
Which of the following commands should be used by the DBA to improve the performance of the queries run against the SALES table?

Question18: Which ALTER TABLE statements will put a table named TAB1 in "reorg-pending" state? (Choose two.)

Question19: What does dsmtop use to gather metrics?

Question20: If the following SQL statements are executed:

How many rows will be added to the DEPARTMENT table?

Question21: Which two tasks must be done to read data directly from IBM Softlayer Object Storage and insert it into a DB2 database? (Choose two.)

Question22: Which command will enable Explicit Hierarchical Locking (EHL) in a DB2 pureScale environment?

Question23: What is an advantage of using range partitioned tables?

Question24: Which of the following enables the user to connect to the HADR standby database and execute select statements?

Question25: Assuming no database connections exist, which of the following will dynamically change the LOCKLIST database configuration parameter for a database named SAMPLE to AUTOMATIC?

Question26: Which of the following commands will list all of the disk configurations of the file system DATAFS in a DB2 pureScale cluster?

Question27: Where does the DB2 Problem Determination tool (db2pd) get information from?

Question28: If the following SQL statements are executed:
CREATE DATABASE testdb AUTOMATIC STORAGE NO;
CONNECT TO testdb;
CREATE STOGROUP sg1 ON '/data1';
CREATE STOGROUP ibmstogroup ON '/data2';
CREATE STOGROUP sg2 ON '/data3';
Which storage group is the default storage group for the TESTDB database?

Question29: Which phase of the LOAD utility is unique to loading column organized tables?

Question30: The HADR_TARGET_LIST parameter enables HADR to run in multiple standby mode. Which of the following statements are TRUE if HADR is active? (Choose two.)

Question31: What levels of authority are needed to create a storage group? (Choose two.)

Question32: If Secure Sockets Layer is a requirement, which of the following parameters must be set to encrypt data in transit?

Question33: What is the default value of the DB2 registry variable DB2LDAP_SEARCH_SCOPE?

Question34: What is the result of the following scenario?

Question35: Which two of the following functions of DB2 Workload Manager are restricted by license? (Choose two.)

Question36: Which of the following statements about audit policies is TRUE?

Question37: What is the main benefit of performing an ADMIN_MOVE_TABLE operation in multiple steps?

Question38: Automatic space reclamation for column-organized tables can be accomplished in which of the following scenarios?

Question39: When querying the MON_GET_TABLESPACE table function, the values for many of the performance metrics like POOL_DATA_P_READS and POOL_DATA_L_READS are showing 0, even though there is activity occurring in the database. Which command must be executed to enable the table function to return actual data?

Question40: Which of the following are all valid types of trigger?

Question41: The DBA is concerned about a new application potentially corrupting a set of tables in table space TS1 in database DB1. TAB1 is a table in TS1. The DBA performs the following commands before running the application. The first QUIESCE completes at time "pit".
BACKUP DATABASE DB1 TABLESPACE (TS1) ONLINE
QUIESCE TABLESPACES FOR TABLE tab1 EXCLUSIVE
QUIESCE TABLESPACES FOR TABLE tab1 RESET
Which of the following is TRUE?

Question42: Which DB2 Explain Facility tool uses the Explain tables to display access plain information?

Question43: Which of the following actions do you need to acquire the current encryption settings for a database protected by native encryption?

Question44: How would you enable self-tuning of memory areas that are controlled by memory configuration parameters?

Question45: Which of the following are valid Explain operators? (Choose two.)

Question46: Which command can be used to view the configured global registry settings for all installed DB2 copies found on a Linux server?

Question47: When choosing the dimensions for an MDC table, poor space utilization can occur due to low cell density.
What can cause an MDC table to use much more space?

Question48: For any given column-organized user table, the associated synopsis table may contain information for which of the following data types? (Choose two.)

Question49: An HADR environment has two standby databases - one principal and one auxiliary. What is the only mode that can be used to transfer data to the auxiliary standby?

Question50: A table named MYTABLE contains an XML column and an XML storage object dictionary already exists.
What is the effect of enabling compression and then running the command REORG TABLE mytable KEEPDICTIONARY?

Question51: You suspect there is a communications issue between a member and a cluster caching facility (CF) in a DB2 pureScale instance. Which command will provide diagnostic information that can be used to confirm your suspicions?

Question52: Which options are valid for an online reorganization operation?

Question53: Which statement regarding event monitors is TRUE?

Question54: Which of the following statements about compression for BLU MPP tables is TRUE?

Question55: Which statement about the db2move command is TRUE?

Question56: Which tool can be used to get database design recommendations based on SQL statements stored in the database package cache?

Question57: Which statement about label-based access control (LBAC) is TRUE?

Question58: Which is the correct way to back up only metadata about database backups, table space backups, and table load operations for database MYDB?